Scotland are out of the 2026 World Cup as they are unable to finish the group stage as one of the eight best third-placed teams.