Assuming a non-clustered index on FOO (and no predicate pushdown by an optimizer smarter than MySQL's), the first query will scan the index on FOO and perform 150000 seeks into clustered index (only to discard 149985 of them):
SELECT * FROM T ORDER BY FOO LIMIT 15 OFFSET 150000
But the following will just scan the index:
SELECT FOO FROM T ORDER BY FOO LIMIT 15 OFFSET 150000