migrations: Remove validation from store on migration application
Created by: efritz
Pulled from #29831. This PR removes the validation from the migration store that ensures we are applying the correct next migration. Once we have multiple parents, there is no next migration derivable from the previous version. This PR also updates the tests associated with up/down migration application behavior.
Reviewers: Review by commit makes the test diff much easier to see.