SNP ministers have confirmed the National Care Service has been scrapped.