Cheers were heard across Manhattan as the lights came back on after a lengthy power outage caused chaos in the city.