Euphoria of Scotland’s France 98 opener with Brazil shows amazing experience which could await Tartan Army at next summer’s Euros