Experimental test of the neoclassical theory of impurity poloidal rotation in tokamaks