Northern Ireland celebrated a World Cup qualifying play-off place despite a 1-0 defeat in Norway as Scotland's bid ended in heartache.