The Madhya Pradesh CM ordered the transfer of SP Ravi Bhadoriya and the suspension of eight police personnel and ordered a detailed investigation into the tragedy