A weather formation resembling a huge wave, known as a shelf cloud, has been spotted off the coast of Sydney.