Emergence of rotational bands in ab initio no-core configuration interaction calculations of light nuclei