Hundreds of people across Scotland, Northern Ireland and northern parts of England spotted an unusual fireball lighting