Western Europe has officially recorded its hottest June on record, triggering red extreme heat warnings and widespread disruption across the UK.