A yellow heat health alert has been issued for large parts of the UK later this week - as the Met Office said it was provisionally the hottest June on record in England.