How does prisma know the dependency between migrations? Is it just based on the timestamps of the generated migration files?

It also keeps a table in your database that tracks all the migrations.