A red weather warning for wind has been issued, with gusts expected to reach up to 100mph in parts of Scotland.