More than two million tablets, including Valium, were found by Police Scotland last year.