Conservative Parliamentary candidate Nick Rose has resigned following backlash over his controversial comments about transgender people and migrants during a school debate.