Unlocking dynamics of goal-scoring: the showdown between direct and indirect transition goals across football leagues