Thousands of Tartan Army foot soldiers lit up Cologne as they marched to the skirl of the pipes amid incredible pre-match scenes.