The Met Office has warned of ‘significant disruption’ for revellers in Scotland on Hogmanay