No it has no modem. For Virgin you’d just put their box in modem mode then connect an Ethernet cable to the WAN port.
For Openreach xDSL connections it depends, but modem mode is quite rare. The Vigor 130 does just this, it totally replaces your ISP kit (not Sky though) and has an Ethernet out, so it’s a convertor if you like. You put your ISP user ID and password into the Belkin. I’ve not seen any BT full fibre kit so no idea there, but my Virgin router is exactly the same. I suspect the Openreach kit is too.