Scotland hold on in last-over thriller against Oman