A Met Office yellow weather alert for all of Scotland expired at midnight, but a smaller warning area for high winds remains.