The Met Office has said people in the north are "most likely" days to catch a glimpse of the natural phenomenon today and tomorrow