Aliens, black holes and far-off galaxies were some of the suggested explanations for a spectacular spiral light which appeared in the skies over Yorkshire and Lincolnshire on Monday.