if you use rownum you almost always see full table scan but in practice Oracle is pretty clever, it doesnt actually do the FTS

Also if you see statsitics you see consistent gets and db block gets and phy read are all 0