Pep Guardiola claimed his first victory as Manchester City manager with a 6-5 penalty shoot-out success over Borussia Dortmund.