Methyl orange is a pH indicator frequently used in titrations because of its clear and distinct colour change. Under acidic conditions, it is red or pinkish red and under alkaline conditions, it turns yellow.

Let's consider each of the options :

Option A : When a weak base is titrated against a strong acid, the solution at the end point is slightly acidic. However, the color change from colorless to pink is not associated with methyl orange.

Option B : When a strong base is titrated against a strong acid, the solution is neutral at the end point. Methyl orange changes color from pinkish-red in acidic conditions to yellow in basic conditions, so this color change doesn't match the description.

Option C : When a weak base is titrated against a strong acid, the solution is slightly acidic at the end point. Methyl orange would change from yellow in the basic solution to red in the acidic solution at the end point. This corresponds to a "yellow to pinkish-red" color change.

Option D : When a strong base is titrated against a strong acid, the solution is neutral at the end point. The color change described here is "pink to colorless" which does not correspond with the characteristic changes of methyl orange.

Therefore, the correct answer is Option C: Weak base, Strong acid, Yellow to pinkish-red.