Methyl orange is weak organic base. It is used in the titration of weak base vs strong acid.
In basic medium, equilibrium lies in backward direction, and therefore it shows yellow colour.
In acidic medium, equilibrium shifts in forward direction and therefore, colour changes from yellow to red.