The Met Office has issued a red weather alert for extreme heat while temperatures could reach new highs.