Apple TV does not support 1080p.
Fortunately, most higher end TVs do support 1080i and 720P. They do this through upscaling circuitry. Think of it this way...your TV is 1080P, so everything it shows has to be upscaled to 1080P, unless it is native 1080P. Right now, the only sources of native 1080P that I know of are BluRay and HD DVD.
So everything else is upscaled.
Your Apple TV is natively in 720P. For best results, I would set the ATV to 720P, and let your Sony upscale it automatically to 1080P.
Alternatively, you could have the ATV upscale from 720P to 1080i, and then let your TV take it the rest of the way from 1080i to 1080P.
Which way is best is dependent on how good the upscaling algorithms are in your TV, how good they are in the ATV, and ultimately may rest on the eye of the beholder.
By the way, just about any 1080P TV looks great while playing 1080P source, or even 1080i source. But the higher end sets do a much better job of upscaling from lower resolutions to make it look good on the 1080p screen.