Pep Guardiola believes Manchester City midfielder Rodri has what it takes to become a manager, but the Spaniard has revealed he wants to be a sporting director instead