Met Office upgrades temperature forecast for London leaving millions facing uncomfortably warm nights