More than 50% of medical graduates are female but only 7% of consultant surgeons are women, a report has found.