A comet last seen for Earth some 80,000 years ago has been spotted in North-East England.