Scotland sets ‘shocking and unusual’ weather record