Rising fuel bills and living expenses have put the breaks on demand for new cars, a motor trade body says.