Optimize MySQL indexes for transition model

See https://github.com/gocardless/statesman/issues/59 for more details.