But, as much as science can explain the colours we’re seeing, there’s something undeniably magical about a red sunset