Heatwave conditions intensify across parts of England and Wales as the Met Office issues a rare red warning for extreme heat.