When I was in Edinburgh a dozen years ago, I heard it a lot.

Listen closely to "Dr. No," etc., and you'll hear Sean Connery saying it regularly.

In my experience, it isn't as, er, "pronounced" as strongly as the letters "sh" might suggest.