Democrat Zohran Mamdani - who described himself as "Trump's worst nightmare" - is set to become New York's next mayor, Sky's US partner network NBC News projects.