More than 1 million people were estimated to have descended to watch the traditional fireworks at Sydney Harbour as Australians welcome 2025.