The natural light display, also known as Aurora Borealis, will be seen 'across the very far north of England'