A world-famous musician was among revellers in Sydney Harbour as fireworks lit up the New Year’s Eve sky.