Mark McDonald, the SNP minister for childcare and early years, apologised "to anyone I have upset" as he stepped down from the role.