Scotland assistant manager Mark McGhee says Scotland's opening Euro 2016 qualifier against world champions Germany is exciting.