Scotland scored two late goals in as many minutes to snatch a dramatic win against Norway in their Euro 2024 qualifier in Oslo.