The rare phenomenon illuminates skies across the north-east of England and parts of Scotland.