A mysterious spiralling orb caught the attention of people across Wales last night