At least two people have died and more than 30 are injured after a bridge collapsed in India, officials have said.