Not an apex domain
The domain mail.royce.web.myhostingspace.co.uk is not the root of its zone.
Instead, try zone transfer on royce.web.myhostingspace.co.uk .
Instead, try zone transfer on royce.web.myhostingspace.co.uk .