The Met Office said it was unusual for the UK's highest August temperature to be recorded in Scotland.