The Prime Minister spoke out after the former SNP chief executive admitted embezzling £400,000 from the party