Latvia's prime minister has resigned after accepting political responsibility for the collapse of a supermarket roof in the capital that killed 54 people.