To expand on Tom Goodwillie's answer:

a precise definition of "motivic sphere" would be
$$S^{p,q} = \big( \Delta^{p-q} / \partial \Delta^{p-q} \big) \wedge \big( \bigwedge^q \mathbb{G}_m\big)$$
which you can interpret as the $q$-fold smash product of the multiplicative group $\mathbb{G}_m$ smashed with a $(p-q)$-dimensional simplicial sphere. This smash product makes sense in a category of simplicial presheaves on smooth schemes (which is what you work with in A¹-homotopy theory).

The indices can be explained from looking at the motive $M(S^{p,q}) = \mathbb{Z}(q)[p]$ or at the realizations, where the complex realization gives $S^p$ and the real realization gives $S^{p-q}$. More about this can be read in the Morel-Voevodsky paper.

Now these are not algebraic varieties, by definition, so a good question is

For integers $p$ and $q$, does an algebraic variety $X$ exist which is A¹-weakly equivalent to $S^{p,q}$?

We'll also say "$X$ is a $S^{p,q}$".
From looking at realizations you can already exclude $p,q$ negative.
One positive example is (by definition) $\mathbb{G}_m$, which is a $S^{1,1}$.

As Tom Goodwillie explained, $\mathbb{A}^n / (\mathbb{A}^n \setminus 0)$ is a $S^{2n,n}$ (which some people shorten to "motivic $2n$-sphere") and $\mathbb{A}^n \setminus 0$ is a $S^{2n-1,n}$.

There is not much known beyond that, I suppose.

There are even more varieties that could count as algebraic versions of spheres. An interesting feature of algebraic geometry is that you can look at many fields of definition. Projective quadrics over the complex numbers all look the same (in each dimension), as they are isomorphic (given the same dimension) to the split quadrics $Q_{2n}^{split} = \{\sum_{i=0}^n x_iy_i = 0\}$ or $Q_{2n+1}^{split} = \{\sum_{i=0}^n x_iy_i = z^2\}$ as well as to the anisotropic quadrics $Q_{m} = \{\sum_{i=0}^m z_i^2\}$ (by change of basis). Over smaller, non-quadratically closed fields, these quadrics are no longer isomorphic.

Now look at the affine quadrics inside the projective quadrics (by removing a suitable hyperplane section). Conjecturally, the split ones are motivic spheres (at least they have the right motive), while the anisotropic ones aren't. You can consider these forms of motivic spheres.

preciseways of phrasing the sentiment that spheres are the simplest closed manifolds. – Tom Leinster Dec 7 '12 at 12:18