Scotland missed out on becoming the first country other than hosts Germany to book their place at Euro 2024 on Thursday night, losing 2-0 in Spain thanks to a pair of second half goals.