Cristiano Ronaldo came off the bench to score the winner as Portugal earned a 2-1 victory, condemning Scotland to another late defeat.