Tens of thousands of patients left “in limbo” waiting for cancer diagnoses, charity warns