A photographer was left stunned after capturing a red 'aurora' over the UK - but it turns out it was something much rarer than the Northern Lights