In a major political upset, the Scottish Conservatives have won the Aberdeen South parliamentary by-election, taking a Westminster seat from the Scottish National Party in a contest that became a referendum on the future of the North Sea oil and gas industry.