The number of primary school children as young as five being expelled due to their behaviour is a “shocking indictment on society”, say councillors.