The BBC has apologised after Jeremy Clarkson declared that he would like to see striking public sector workers "shot" in front of their families.