A night of laughter turned into a whirlwind of emotions at Peter Kay's Manchester show as one woman was left in floods of tears.