Offshore web hosting means that the web server is being hosted offshore of you in a completely different country than where you reside.
Some people host websites on offshore hosting that are forbidden in the united states or in their country.
That's really only when you need offshore hosting. Offshore hosting won't improve your website or anything.
So only do offshore hosting for your website if you're hosting something that might be illegal in your country.