The Tories have been celebrating winning their first Scottish by-election for more than 50 years.