An albino whale known as Migaloo has been spotted off the coast of Sydney in an event onlookers called a once-in-a-lifetime experience.