More than 1 million revellers braved the heaving crowds to watch tens of thousands of fireworks light up Sydney Harbour in spectacular fashion.