October's short-lived heatwave will come to an end this week with temperatures set to plunge thanks to the remnants of Hurricane Ophelia.