I have a friend here at work who is from Scotland. We talk about football (soccer) on occasion. I like England, he doesn't. Scotland failed to qualify for the Euros when they lost to Italy. England needed only a draw against Croatia (at home, at Wembley) to go to the tournament. England lost 3-2.
My friend was disappointed Scotland didn't qualify but I don't think he really expected them to (his hopes have been dashed too many times). But he was really happy England failed to qualify. He was positively gleeful or at least as gleeful as Scottish people get.
Wikipedia defines Schadenfreude as "pleasure taken from someone else's misfortune." The Scots are very happy right now.