def pull_all_lipo_ids(conn):
    """
    Pull all lipophilicity molregnos, sorted by molregno value

    conn: database connection

    returns list of ids
    """
    cur = conn.cursor()
    sql = '''
    SELECT  molregno
    FROM    lipophilicity
    ORDER BY molregno
    '''
    cur.execute(sql)
    return [row[0] for row in cur]