Eight people died after a section of stands at a football stadium in Brazil collapsed as fans cheered at the end of a game on Sunday, police said.