Met Office reveals how long ‘unseasonal’ October heat will last