Demand for new cars equipped with a manual transmission has dropped to a record low, new data reveals.