Do you know if it's safe to manually wipe the hosts table in the DB? By safe I mean if everything is expected to work fine after that and the clients will be enrolled back automatically

I would expect it to work like that, but definitely recommend backing up your DB before trying.