The longer the longest blockchain is, the harder it is to get overtaken by new blockchain with different sequence of transactions.
But is there a case where it happened? What happened afterwards if there's so many transactions which got deleted or override by new blockchain?