In which order are cards drawn from the dungeon pile
According to the publisher, you do not shuffle the cards, you simply flip over the most recently added card, and then proceed, finally ending with the card that was added first.

So as you play you are building up the stack of dungeon cards, and then you go back through them in LIFO order (last in first out).