For clustered indexes (non-heap tables) No, for Non-clustered indexes Yes, for heaps No. As the process reads the structure of the table bottom up and takes the "last" part and moves it to the "free" space (slightly simplified), it is kind of an inside-out operation, just like socks would be wrong way around.

😎