Leftover rice is drier than just-cooked rice; hence, it will give you that perfect chewy but still firm-fried rice texture.  Newly cooked rice will generally result in soggy fried rice because there's too much moisture in it.