The real reason is that the identity matrix is, by definition, in rref with a leading 1 on the diagonal and zeroes everywhere else. Therefore there is a pivot position in each column (and row), and there are n columns (and row). There are also some geometric interpretations, but I'm pretty sure it all boils down to this property at the end anyways.