US mayor apologises for saying LGBT+ people and abortion rights campaigners should be killed